Model Table PROJ START DATE

Attributes

Attribute Description (where applicable)
Current Month FlagCurrent month flag, day in current month
Current Year FlagCurrent year flag, day in current yea
Last 12 Months FlagLast 12 months flag, day between curr month-1 and curr month-12
Last 24 Months FlagLast24 months flag, day between curr month-24 and curr month-1
Proj Start DateProject Start Date
Proj Start Date StringDate as string, fixed format, not NLS dependent
Proj Start MonthProject Start Month
Proj Start Month NoProject Start Month Number
Proj Start Month ShortMonth short, 3 char, NLS dependent
Proj Start QuarterQuarter, not NLS dependent
Proj Start WeekdayWeek Day
Proj Start Weekday NoWeek Day Number
Proj Start YearYear, NLS dependent
Proj Start Year MonthYear month
Year (Week based)Year, NLS dependent
Proj Start Week NoWeek Number

Hierarchies

Hierarchy Level
ProjStartMSHy
Proj Start Year
Proj Start Quarter
Proj Start Month
ProjStartMFHy
Proj Start Year
Proj Start Quarter
Proj Start Month
Proj Start Date
ProjStartWSHy
Proj Start Year
Proj Start Week No
ProjStartWFHy
Proj Start Year
Proj Start Date
Proj Start Week No

USED BY MODEL(S)

Model Name

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table DW Source view (SQL Server) BI Access View Referenced Information Source Recommended Access Type
PROJ START DATEDIM_BI_TIME_TMDIM_BI_TIME_BIDIM_BI_TIMEOn Line